What are the commonly used SQL statements

This article will explain in detail what commonly used SQL sentences are, the editor thinks it is very practical, so share it for you to do a reference, I hope you can get something after reading this article. Note: the following 50 statements have been tested according to the test data, and it is best to run only one language at a time

2022-05-31 Database 我要分享

SID Filtering Chinese version of bug

It has been nearly a year since Lao Wang released a series of articles on migration of shared permissions. The series of articles on file server migration written at that time seemed perfect, but in fact, for Lao Wang, I could only give myself a score of 80. Why? because I didn't do it when I tested SID Filtering at last.

2022-06-02 Servers 我要分享

The relationship between oracle sid,instance_name,db_name,oracle_sid

[1] understanding of ORACLE_SID-Ora

2022-06-01 Database 我要分享

How to use function in MySQL Multi-table query

The following mainly brings you how to use functions in MySQL multi-table queries. I hope these contents can bring you practical use, which is also the main purpose of this article on how to use functions in editing MySQL multi-table queries. All right, don't talk too much nonsense, let's just read the following. 1. Multi-table combination check

2022-06-01 Database 我要分享

How to understand SID and its usage

What this article shares with you is about how to understand SID and its usage. The editor thinks it is very practical, so I share it with you. I hope you can get something after reading this article. Problem background: when installing the database, a SI was found

2022-05-31 Database 我要分享

Remember an ORA-00210,ORA-00202,ORA-27086 error in the process of building DG.

ORA-00210: cannot open the specified control fileORA-00202: control file:'/ u01/app/oracle/oradata/o

2022-06-01 Database 我要分享

Windows Server 2012 Clone modified SID

After changing the SID, the blue screen\ black screen: environment: Windows Server 2012 R2 purpose: the SID of the cloned system is all the same, so I want to modify the SID phenomenon of each system: the SID of the cloned system is the same, so I want to modify the S of each system.

2022-06-02 Servers 我要分享

Oracle modifies SID

Problem description: my default ORACLE_SID was orcl, but now I want to do data synchronization. I have to have a different ORACLE_SID to distinguish it from each other. Now it only takes a few simple steps to modify the ORACLE_SID;1. First

2022-06-01 Database 我要分享

Configuration of ORACLE multiple instance snooping

There are three configurations for multi-instance listening: 1. One listener listens to multiple instances on one IP port 2, one listener listens to multiple instances on different IP ports 3, and multiple listeners listen to multiple instance 1:listener.ora files: # listener.o

2022-06-01 Database 我要分享

How to analyze the waiting event enq TX row lock contention

This article shows you how to analyze the waiting event enq TX row lock contention. The content is concise and easy to understand. It will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article. Normally, Ora

2022-05-31 Database 我要分享

Oracle checks the lock table and handles the lock table

/ locked*query locked object and analyse reason,kill it*/select 'alter system kill session''| | SI

2022-06-01 Database 我要分享

Pid,sid search each other, query sql according to PID

There are three ways to view the session ID of the current session: 1. V$mystat view SQL > select sid from v$mystat where rownum=1;SID-115

2022-06-01 Database 我要分享

What if there is an ORA-00054 error in Oracle?

This article mainly introduces the Oracle ORA-00054 error how to do, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian with you to understand. In the process of database maintenance

2022-06-01 Servers 我要分享

How to To Findout sessions or SQLs

How To Findout sessions/users/ SQL's which consuming High CPU usage in Oracle Database.I been monito

2022-06-01 Database 我要分享

Oracle TNS Listener Remote Poisoning test

The remote data poisoning vulnerability (CVE-2012-1675) allows a user to poison data processed by a remote "TNS Listener" component without providing a username / password. COST is class of secure tran.

2022-06-01 Database 我要分享

ADMT migration: retain access to source domain resources during migration

I have previously published an article on domain object migration using ADMT. The connection is as follows: https://blog.51cto.com/hubuxcg/1554925https://blog.51cto.com/hubuxcg/1554

2022-06-03 Servers 我要分享

Using DATABASE Log off to collect oracle wait event information

Instance-level monitoring, always on and with low overhead: building basic tables: create table sys.sesstat_history tablespace EOL asSELECT c.username, c

2022-06-01 Database 我要分享

Popular explanation and Experimental case of Oracle level 0 to 6 Lock

Lock information extracted from 11g Concepts Table Locks (TM) A table lock, also called a TM lock, is acquired by a transactio

2022-06-01 Database 我要分享

Whether the oracle table is locked

Select t2.username v$locked_object t2.sidrecoveryt2.serialpublication journal t2.logonedtimefrom username T1 copyright vested session t2where t1.sessi

2022-06-01 Database 我要分享

How to implement backup and recovery Test from Oracle DG Library Rman

This article mainly introduces Oracle DG from the library Rman how to achieve backup recovery testing, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to know about it. 1. System initialization and data

2022-05-31 Database 我要分享